package com.aier.bean.inventory;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.VerticalAlignment;

/**
 * 商品汇总表
 */


@Data
@NoArgsConstructor
@AllArgsConstructor
@ContentRowHeight(25)
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
public class InventoryRecordsBean {
    @ExcelProperty(value = "型号")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(50)
    private String modelName;

    @ExcelProperty(value = "型号2")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(50)
    private String sku;

    @ExcelProperty(value = "业务员")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(15)
    private String salesperson;

    @ExcelProperty(value = "现库存总汇")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER, fillPatternType = FillPatternType.SOLID_FOREGROUND, fillForegroundColor = 13)
    @ColumnWidth(15)
    private Integer currentInventory;

    @ExcelProperty(value = "出库总汇")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER, fillPatternType = FillPatternType.SOLID_FOREGROUND, fillForegroundColor = 17)
    @ColumnWidth(15)
    private Integer outInventory;

    @ExcelProperty(value = "入库总汇")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER, fillPatternType = FillPatternType.SOLID_FOREGROUND, fillForegroundColor = 40)
    @ColumnWidth(15)
    private Integer inInventory;

    @ExcelProperty(value = {"1号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer oneIn;

    @ExcelProperty(value = {"1号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer oneOut;

    @ExcelProperty(value = {"2号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twoIn;

    @ExcelProperty(value = {"2号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twoOut;

    @ExcelProperty(value = {"3号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer threeIn;

    @ExcelProperty(value = {"3号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer threeOut;

    @ExcelProperty(value = {"4号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fourIn;

    @ExcelProperty(value = {"4号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fourOut;

    @ExcelProperty(value = {"5号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fiveIn;

    @ExcelProperty(value = {"5号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fiveOut;

    @ExcelProperty(value = {"6号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sixIn;

    @ExcelProperty(value = {"6号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sixOut;

    @ExcelProperty(value = {"7号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sevenIn;

    @ExcelProperty(value = {"7号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sevenOut;

    @ExcelProperty(value = {"8号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer eightIn;

    @ExcelProperty(value = {"8号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer eightOut;

    @ExcelProperty(value = {"9号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer nineIn;

    @ExcelProperty(value = {"9号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer nineOut;

    @ExcelProperty(value = {"10号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer tenIn;

    @ExcelProperty(value = {"10号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer tenOut;

    @ExcelProperty(value = {"11号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer elevenIn;

    @ExcelProperty(value = {"11号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer elevenOut;

    @ExcelProperty(value = {"12号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twelveIn;

    @ExcelProperty(value = {"12号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twelveOut;

    @ExcelProperty(value = {"13号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirteenIn;

    @ExcelProperty(value = {"13号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirteenOut;

    @ExcelProperty(value = {"14号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fourteenIn;

    @ExcelProperty(value = {"14号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fourteenOut;

    @ExcelProperty(value = {"15号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fifteenIn;

    @ExcelProperty(value = {"15号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer fifteenOut;

    @ExcelProperty(value = {"16号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sixteenIn;

    @ExcelProperty(value = {"16号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer sixteenOut;

    @ExcelProperty(value = {"17号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer seventeenIn;

    @ExcelProperty(value = {"17号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer seventeenOut;

    @ExcelProperty(value = {"18号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer eighteenIn;

    @ExcelProperty(value = {"18号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer eighteenOut;

    @ExcelProperty(value = {"19号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer nineteenIn;

    @ExcelProperty(value = {"19号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer nineteenOut;

    @ExcelProperty(value = {"20号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyIn;

    @ExcelProperty(value = {"20号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyOut;

    @ExcelProperty(value = {"21号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyOneIn;

    @ExcelProperty(value = {"21号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyOneOut;

    @ExcelProperty(value = {"22号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyTwoIn;

    @ExcelProperty(value = {"22号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyTwoOut;

    @ExcelProperty(value = {"23号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyThreeIn;

    @ExcelProperty(value = {"23号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyThreeOut;

    @ExcelProperty(value = {"24号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyFourIn;

    @ExcelProperty(value = {"24号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyFourOut;

    @ExcelProperty(value = {"25号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyFiveIn;

    @ExcelProperty(value = {"25号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyFiveOut;

    @ExcelProperty(value = {"26号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentySixIn;

    @ExcelProperty(value = {"26号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentySixOut;

    @ExcelProperty(value = {"27号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentySevenIn;

    @ExcelProperty(value = {"27号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentySevenOut;

    @ExcelProperty(value = {"28号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyEightIn;

    @ExcelProperty(value = {"28号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyEightOut;

    @ExcelProperty(value = {"29号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyNineIn;

    @ExcelProperty(value = {"29号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer twentyNineOut;

    @ExcelProperty(value = {"30号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirtyIn;

    @ExcelProperty(value = {"30号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirtyOut;

    @ExcelProperty(value = {"31号", "入库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirtyOneIn;

    @ExcelProperty(value = {"31号", "出库"})
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    private Integer thirtyOneOut;
}
